Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_8600

R_8600

DayInterval

Event

DayIntervalID

 

 

R_8620

R_8620

TimePatternTimeSlot

LOrgUnitTimePatternTimeSlot

TimePatternTimeSlotID

 

 

R_8622

R_8622

ExternalOrgUnit

LOrgUnitTimePatternTimeSlot

ExternalOrgUnitID

 

 

R_8623

R_8623

TimePatternTimeSlot

LDoctorTimePatternTimeSlot

TimePatternTimeSlotID

 

 

R_8624

R_8624

Person

LDoctorTimePatternTimeSlot

PersonID

 

 

R_8741

R_8741

Person

LReservationStatus

PersonID

 

 

R_8901

R_8901

TimeStamp

TimeStampRule

StartTimeStampID

 

 

R_8902

R_8902

TimeStamp

TimeStampRule

StopTimeStampID

 

 

R_8903

R_8903

Service

TimeStampRule

RuleServiceID

 

 

R_8904

R_8904

ServiceType

TimeStampRule

RuleServiceTypeID

 

 

R_8905

R_8905

Attribute

TimeStampRule

RuleAttributeID

 

 

R_8906

R_8906

Service

TimeStampRule

CostServiceID

 

 

R_8907

R_8907

TimeStampMultiplicityKind

TimeStampRule

TimeStampMultiplicityKindID

 

 

R_8908

R_8908

TimeStampMultiplicityKind

TimeStampMultiplicityKindText

TimeStampMultiplicityKindID

 

 

R_8911

R_8911

TimeStampRule

PerfService

TimeStampRuleID

 

 

R_8912

R_8912

SysFct

TimeStampRule

SysFctID

 

 

R_8993

R_8993

LServiceTimePatternTimeslot

LServiceTPBodyPartDuration

LServiceTimePatternTimeslotID

 

 

R_8994

R_8994

DictionaryValue

LServiceTPBodyPartDuration

DictionaryValueID

 

 

R_9087

R_9087

WaitingList

TimePattern

WaitingListID

 

 

R_9170

R_9170

Reservation

AutoRegistrationLog

ReservationID

 

 

R_9171

R_9171

RegistrationValidationType

AutoRegistrationLog

RegistrationValidationTypeID

 

 

R_9172

R_9172

RegistrationValidationType

RegistrationValidationTypeText

RegistrationValidationTypeID

 

 

R_9212

R_9212

ExternalOrgUnit

LPatientDayInterval

ExternalOrgUnitID

 

 

R_9412

R_9412

DescriptiveData

LReservationDescriptiveData

DescriptiveDataID

 

 

R_9413

R_9413

Reservation

LReservationDescriptiveData

ReservationID

 

 

R_9427

R_9427

TimeSlotType

TimePatternTimeSlot

UserDefinedTimeSlotTypeID

 

 

R_9885

R_9885

Reservation

ReservationAddOns

ReservationID

 

 

R_9923

R_9923

Color

Marker

ColorID

 

 

R_9924

R_9924

Marker

MarkerText

MarkerID

 

 

R_9925

R_9925

MarkerContext

MarkerContextText

MarkerContextID

 

 

R_9926

R_9926

MarkerContext

Marker

MarkerContextID

 

 

R_10137

R_10137

TimeStamp

RangeDefForTimeStamps

BeginTimeStampID

 

 

R_10138

R_10138

TimeStamp

RangeDefForTimeStamps

EndTimeStampID

 

 

R_10139

R_10139

FormDefinition

RangeDefForTimeStamps

FormDefinitionID

 

 

R_10140

R_10140

RangeDefForTimeStamps

LPerfServiceRangeDefinition

RangeDefinitionID

 

 

R_10141

R_10141

PerfService

LPerfServiceRangeDefinition

PerfServiceID

 

 

R_10225

R_10225

Color

ColorText

ColorID

 

 


1  2